﻿use kwr
go

CREATE PROCEDURE [dbo].[GetAllChaosTransformations]
	@kwrName varchar(100)
AS

select t.a, t.b, t.c, t.d, t.e, t.f
from dbo.chaos kn
inner join dbo.ChaosTransformations t on kn.id = t.Chaosid
where kn.name = @kwrName 
order by t.Id

RETURN 0